SQL Server Tips, Articles and Training

Power BI Quick Reference Guide

Check out this structured reference guide to just about anything you want to know about Power BI and Power BI report development.

Text Cleaning and Preprocessing with Python for NLP Tasks

This tip introduces basic text preprocessing and cleaning techniques with Python that can be used before feeding the data to a machine-learning model.

What is Change Management and the SQL Server DBAs Role

This article will explain Change Management, how DBAs are involved and can benefit from implementing standard processes for all database changes.

Popular Right Now

1 - Querying SQL Server Agent Job Information

2 - Run same command on all SQL Server databases without cursors

3 - Simple Image Import and Export Using T-SQL for SQL Server

Disaster Recovery in the Cloud: Understanding Challenges and Strategies for SQL Server

Calculating Costs for Microsoft SQL Server

Get Free SQL Tips

Azure

Implement Azure Database for MySQL Step-by-Step

Learn how to implement MySQL on the Azure platform in this step-by-step article using an Azure Database for MySQL flexible server deployment.

Power BI

Power BI Export to Excel

Learn how you can export millions of rows of data out of Power BI to either a CSV or Excel file.

Performance Tuning

Uncover SQL Server Missing Indexes

In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.

XML

Working with XML data in SQL Server

In this article, we look at what you need to know to work with XML data in SQL Server.

Microsoft Fabric

API for GraphQL in Microsoft Fabric

Learn how to share data currently stored in a Microsoft Fabric warehouse using a GraphQL API along with the steps to set this up.

Azure SQL Managed Instance

Azure Managed Instance Download and Restore SQL Server Backup

Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.

Cloud Strategy

How to Design a Real-Time Streaming Platform with Azure

Learn how to design a real-time streaming platform that captures data as they are generated and stored in the necessary storage for decision-making.

Indexing

SQL Index Rebuild vs Reorganize Comparison

This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.

Performance Tuning

Identify CPU Intensive SQL Server Queries from an Implicit Conversion

Learn how to use the SQL Server Query Store to find CPU-intensive queries and how you can use Query Store to resolve these issues.

PowerShell

Run PowerShell Scripts with SQL Server Agent or Windows Task Scheduler

Learn how to schedule and automate your PowerShell scripts using either SQL Server Agent or Windows Task Scheduler.

Database Configurations

SQL Server Connection Strings using SqlClient, OLDEDB and ODBC

In this article we look at different ways to define a connection string to connect to SQL Server using SqlClient, OLDEDB and ODBC connections.

Power BI

DAX CASE Statement Functionality with IF, SWITCH and SWITCH True

DAX does not have a CASE statement, so we look at other options that have similar functionality such as IF(), SWITCH(), and SWITCH(TRUE()).

Tutorial

SQL Server Differential Backups

Learn how to create differential backups to capture only the most recent changes since the last full backup.

Tutorial

SQL Server Integration Services SSIS 2016 Tutorial

This is an overview of the SSIS 2016 tutorial and the various things that will be covered.

Tutorial

SQL PATINDEX Function Use and Examples

Learn how to use the SQL Server PATINDEX function to search for specific patterns within a string.

Whitepaper

SQL Server Performance Tuning Checklist

This SQL Server checklist will serve as a starting point to help determine what steps might make sense as part of a performance improvement effort.

Webcast

Simplified Multi-Platform Database Management for Managed Service Providers (MSPs)

Databases are the components that utilize the most resources in the data center. Unfortunately, there are not enough database professionals to always

Webcast

Easily Create Non-Sensitive Copies of Production Databases

Learn how to obfuscate sensitive data and personally identifiable information (PII), all while ensuring the data remains useful for testing and analys